AdEnrollRegistration 
Logical Entity Name  AdEnrollRegistration 
Default Table Name  AdEnrollRegistration 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

AdEnrollRegistration Columns 
ColumnName  Domain  Datatype  NULL  Definition 
AdEnrollRegistrationID    int  NO 
 
AdEnrollID(PK)(FK)    int  NO 
 
AdClassSchedID(PK)(FK)    int  NO 
 
AdTermID(PK)(FK)    int  NO 
 
ReservationExpires    datetime  YES 
 
DateRegistered    datetime  YES 
 
Status    smallint  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
UserID(FK)    int  NO 
 
WaitListDate    datetime  YES 
 
ResultCode    int  YES 
 
ResultDetail    varchar(800)  YES 
 
ts    timestamp  NO 
 
IsAdvisorApproval    bit  YES 
 
ParentTermId    int  YES 
 
AdCourseStatusChangeReasonID(FK)    int  YES 
 
RetakeFeeWaived    char(1)  NO 
 
Credits    money  YES 
 
Hours    money  YES 
 
PaymentDetails    xml  YES 
 
AdCourseFeeSchedID    int  YES 
 
IsPassFail    bit  NO 
 

AdEnrollRegistration Primary and Unique Keys 
Key Name  Key Type  Keys 
AdEnrollRegistration_AdEnrollRegistrationID_U_N_IDX  Index  AdEnrollRegistrationID 
AdEnrollRegistration_AdEnrollID_AdClassSchedID_AdTermID_U_C_IDX  PrimaryKey  AdEnrollID, AdClassSchedID, AdTermID 

AdEnrollRegistration Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdClassSched  Identifying  One To Zero or More  FK_AdEnrollRegistration_AdClassSched_AdClassSched_AdClassSchedID      AdClassSchedID  NO  YES 
AdEnroll  Identifying  One To Zero or More  FK_AdEnrollRegistration_AdEnrollID_AdEnroll_AdEnrollID      AdEnrollID  NO  YES 
AdTerm  Identifying  One To Zero or More  FK_AdEnrollRegistration_AdTermID_AdTerm_AdTermID      AdTermID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_AdEnrollRegistration_UserID_SyStaff_SyStaffID      UserID  NO  YES 
AdCourseStatusChangeReason  Non-Identifying  Zero or One to Zero or More  FK_AdEnrollRegistrationAdCourseStatusChangeReasonID_AdCourseStatusChangeReasonAdCourseStatusChangeReasonID      AdCourseStatusChangeReasonID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdEnrollSched  Non-Identifying  One To Zero or More  FK_AdEnrollSched_AdEnrollRegistrationID_AdEnrollRegistration_AdEnrollRegistrationID        NO  YES 

AdEnrollRegistration Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_AdEnrollRegistration_ReservationExpires  ([Status] & 256 = 256 and [ReservationExpires] is not null or [Status] & 256 = 0 and [ReservationExpires] is null) 

AdEnrollRegistration Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group  PRIMARY 

AdEnrollRegistration Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentCoursePendingRegistration 
NO       
Physical (Microsoft SQL Server)
dbo.AdEnrollRegistration 
NO       

AdEnrollRegistration Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  CourseRegistration 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 

AdEnrollRegistration Data Movement Rules 
Name  Type  Rule Text/Value